oracle 一张表有两个字段,a和b,字段值a=b和b=a,算作一条,怎么操作...答:select data_info,business_a,business_b from (select a.data_info,a.business_a,a.business_b,row_number() over(order by a.business_a) rk -- 按某一字段升序(降序也行)排列 from 表名 a, -- 表自身做关联 表名 b where a.business_a = b.business_b -- 两字段互相等 ...